class CreateProjects < ActiveRecord::Migration
  def self.up
    create_table :projects do |t|
      t.integer :project_id
      t.string :name_th
      t.string :name_eng
      t.text :description
      t.text :abstract
      t.integer :author_id
      t.integer :advisor_id
      t.integer :year
      t.integer :category_id
      t.integer :status
      t.integer :view_times
      t.timestamps :date_submission
      t.integer :visibility     
    end
  end

  def self.down
    drop_table :projects
  end
end
